/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.0.232SQL2016
 Source Server Type    : SQL Server
 Source Server Version : 13001601
 Source Host           : 192.168.0.232\SQL2016:1433
 Source Catalog        : Test
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 13001601
 File Encoding         : 65001

 Date: 06/12/2024 10:00:55
*/


-- ----------------------------
-- Table structure for File
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[File]') AND type IN ('U'))
	DROP TABLE [dbo].[File]
GO

CREATE TABLE [dbo].[File] (
  [F_Id] nvarchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [F_Type] int  NULL,
  [F_Remark] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_FileInfo] nvarchar(1000) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_CreateTime] datetime  NULL,
  [F_CreateUser] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_LastModifyTime] datetime  NULL,
  [F_LastModifyUser] nvarchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_DeleteTime] datetime  NULL,
  [F_DeleteUser] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [F_EnabledMark] int  NULL,
  [F_DeletedMark] int  NULL
)
GO

ALTER TABLE [dbo].[File] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'File',
'COLUMN', N'F_Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'文件类型',
'SCHEMA', N'dbo',
'TABLE', N'File',
'COLUMN', N'F_Type'
GO

EXEC sp_addextendedproperty
'MS_Description', N'文件备注信息',
'SCHEMA', N'dbo',
'TABLE', N'File',
'COLUMN', N'F_Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'文件内容',
'SCHEMA', N'dbo',
'TABLE', N'File',
'COLUMN', N'F_FileInfo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'File',
'COLUMN', N'F_CreateTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建人',
'SCHEMA', N'dbo',
'TABLE', N'File',
'COLUMN', N'F_CreateUser'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改时间',
'SCHEMA', N'dbo',
'TABLE', N'File',
'COLUMN', N'F_LastModifyTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'File',
'COLUMN', N'F_LastModifyUser'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除时间',
'SCHEMA', N'dbo',
'TABLE', N'File',
'COLUMN', N'F_DeleteTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除人',
'SCHEMA', N'dbo',
'TABLE', N'File',
'COLUMN', N'F_DeleteUser'
GO

EXEC sp_addextendedproperty
'MS_Description', N'有效标识',
'SCHEMA', N'dbo',
'TABLE', N'File',
'COLUMN', N'F_EnabledMark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'删除标识',
'SCHEMA', N'dbo',
'TABLE', N'File',
'COLUMN', N'F_DeletedMark'
GO


-- ----------------------------
-- Records of [File]
-- ----------------------------
INSERT INTO [dbo].[File]  VALUES (N'123456789', N'1', N'1', N'[{"name":"8LD.572.1.jpg","fileId":"20241030_621228814474675589.jpg","url":"/api/file/Download?encryption=953E9000EBAF7C89C4B02D8503425C4BC996446E97384DD430C836B7FF97CBE03B9860A10951416D95CB4AAD7A9BCF1E"},{"name":"123.jpg","fileId":"20241030_621229231631762821.jpg","url":"/api/file/Download?encryption=953E9000EBAF7C89C4B02D8503425C4B1FA6690799A70AE8CEF5C0415C3F675FDD45D2420F300E39C8375AB79C24B314"},{"name":"R-C.jpg","fileId":null,"url":"/UploadedFiles/R-C.jpg"}]', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO


-- ----------------------------
-- Primary Key structure for table File
-- ----------------------------
ALTER TABLE [dbo].[File] ADD CONSTRAINT [PK__File__2C6EC723D5977B81] PRIMARY KEY CLUSTERED ([F_Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

